use SMS
drop procedure SMS_GetCategory
go
create procedure SMS_GetCategory
	@categoryId int
as
	select categoryId, categoryName
	from Categories
	where categoryId= @categoryId or @categoryId is null



